﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using Dropthings.DAL;

namespace Dropthings.Business.Facade
{
    partial class Facade
    {
        //获取某个建筑或全部建筑某天的工作时间或非工作时间的各个小时耗气情况
        public DataSet GetGasTimeDatasInWorkTimeOrNot(string identifyCode, int year, int month, int day,bool isWorkTime)
        {
            if (string.IsNullOrEmpty(identifyCode)) return null;
            UQ_GetGasTimeDatasInOrNotinWorkTime query = new UQ_GetGasTimeDatasInOrNotinWorkTime(identifyCode, year, month, day, isWorkTime);
            return query.ExecuteDataset();
        }
        
        //获取某个建筑或全部建筑某月的各天耗气情况
        public DataSet GetGasDayDatasInMonth(string identifyCode, int year, int month)
        {
            if (string.IsNullOrEmpty(identifyCode)) return null;
            UQ_GetGasDayDatasInMonth query = new UQ_GetGasDayDatasInMonth(identifyCode, year, month);
            return query.ExecuteDataset();
        }
        
        //获取某个建筑或全部建筑某年的各月耗气情况
        public DataSet GetGasMonthDatasInYear(string identifyCode, int year)
        {
            if (string.IsNullOrEmpty(identifyCode)) return null;
            UQ_GetGasMonthDatasInYear query = new UQ_GetGasMonthDatasInYear(identifyCode, year);
            return query.ExecuteDataset();
        }

        //获取某一年某个建筑单位(所有建筑单位)的天然气费用
        public DataSet GetGasTotalMoneyInYear(string identifyCode, int year)
        {
            if (string.IsNullOrEmpty(identifyCode)) return null;
            UQ_GetGasTotalMoneyInYear query = new UQ_GetGasTotalMoneyInYear(identifyCode, year);
            return query.ExecuteDataset();
        }
        //获取某一年某个建筑单位(所有建筑单位)各个月的天然气费用
        public DataSet GetGasMonthMoneyInYear(string identifyCode, int year)
        {
            if (string.IsNullOrEmpty(identifyCode)) return null;
            UQ_GetGasMonthMoneyInYear query = new UQ_GetGasMonthMoneyInYear(identifyCode, year);
            return query.ExecuteDataset();
        }
    }
}
